﻿CREATE TABLE [dbo].[Message] (
    [MessageID]          UNIQUEIDENTIFIER NOT NULL,
    [NativeMessageID]    VARCHAR (38)     NULL,
    [FaultID]            UNIQUEIDENTIFIER NOT NULL,
    [ContentType]        VARCHAR (50)     NOT NULL,
    [MessageName]        VARCHAR (50)     NOT NULL,
    [InterchangeID]      VARCHAR (38)     NULL,
    [RoutingUrl]         VARCHAR (512)    NULL,
    [ResubmitAttempted]  BIT              NOT NULL,
    [ResubmitSuccessful] BIT              NOT NULL,
    [InsertedDate]       DATETIME         NULL,
    [ActivityID]         VARCHAR (38)     NULL
);

